| ColumnName |
Domain |
Datatype |
NULL |
Definition |
| Build |
|
int |
NO |
Identifies the version of the software that inserted/updated this row. |
| TouchedBy |
|
varchar(50) |
NO |
The User who last updated the row. IDCode from CV3User table. |
| TouchedWhenUTC |
|
datetimeoffset(3) |
NO |
Date and time the row was last updated. |
| CreatedBy |
|
varchar(50) |
NO |
The User who created the row. IDCode from CV3User table. |
| CreatedWhenUTC |
|
datetimeoffset(3) |
NO |
Date and time the row was created. |
| MSRowVersion |
|
timestamp |
NO |
Optimistic lock identifier. |
| MSReplrowguid |
|
uniqueidentifier |
NO |
Added in order to support Merge Replication. |
| Active |
|
bit |
NO |
Active flag is used for soft deleting or deactivating rows from this table. |
GUID |
|
bigint |
NO |
Primary key |
MatchingWindowSessionGUID |
|
bigint |
NO |
Foreign key from SXAORMMedMatchingSessionsMaster |
| NEHRItemID |
|
varchar(50) |
NO |
NEHR item ID for the medication |